
Use NEXUS_DB

GO
--------------------------------------Insert---------------
CREATE PROC insertBill
	@AccountID varchar(16) ,
	@Money float,
	@Date datetime,
	@Status int ,
	@employeeID int 
AS
INSERT INTO  Bill(AccountID,[Money],Date,Status,employeeID) VALUES(@AccountID,@Money,@Date,@Status,@employeeID)

--insertAccount 'da',1,1,1
GO
---------------------------------------------------update-------------------
CREATE PROC updateStatusBill
	@BillID int,
	@Status int 
AS
UPDATE Bill SET
	Status =@Status
WHERE BillID=@BillID
GO
---------------------------------------Delete--------------------

CREATE PROC deleteBill
	@BillID int
AS
	DELETE FROM Bill WHERE BillID=@BillID
GO
------------------------------------

